BigQuery Datashare

Access Dune’s blockchain data directly in your BigQuery environment

Access 1.5M+ blockchain tables across 50+ chains directly in your BigQuery environment.

How It Works

BigQuery Datashare uses Google Cloud’s dataset sharing to replicate Dune’s data into your project:

• Cross-Project Sharing: Dune grants your project access to shared datasets containing our blockchain data
• Regional Replication: Data is replicated to your preferred region (US Central 1 or EU West 2)
• Native Integration: Shared datasets appear as regular BigQuery datasets in your project
• Automatic Sync: Fresh data arrives daily/hourly without manual intervention

Get Started

Trial: Email [e-mail] or contact enterprise team

Requirements:

• GCP Project ID
• Preferred region (US Central 1 or EU West 2)
• Chains of interest

Sharing Identifiers

BigQuery uses dataset sharing for accessing Dune data:

• Analytics Hub: Shared datasets appear in your project’s Analytics Hub
• Direct sharing: We grant access to specific dataset IDs in your project

Principal Types

We need a “Principal” to grant access. This can be:

Type	Format	Example
User	user:[e-mail]	user:[e-mail]
Service Account	serviceAccount:[e-mail]	serviceAccount:[e-mail]
Domain	domain:domain.com	domain:acme.com
Project Service Accounts	principalSet://cloudresourcemanager.googleapis.com/projects/PROJECT_NUMBER/type/ServiceAccount	All service accounts for project

Most common: provide your email address or a service account email. We can share complete blockchain history in seconds.

See GCP Principal Identifiers documentation for more details.

Data Types

BigQuery uses native types for blockchain data:

Addresses & Hashes

-- Query using BYTES
WHERE tx_hash = FROM_HEX('efb2e2c26974f72d9f3f04c693db73ecc679dd60')
-- Or STRING
WHERE tx_hash_hex = '0xefb2e2c26974f72d9f3f04c693db73ecc679dd60'

Large Integers

BigQuery’s BIGNUMERIC handles uint256/int256 natively:

WHERE value > CAST('1000000000000000000000' AS BIGNUMERIC)

Event Logs

SELECT block_number, topics, data
FROM `project.ethereum.logs`
WHERE topics[OFFSET(0)] = FROM_HEX('ddf252ad...')

Query Optimization

• Use block_time in WHERE clauses for partitioning
• Select only needed columns
• Tables are clustered by common query patterns

Regions

Region	Chains	Freshness
US Central 1	50+	24 hours
EU West 2	50+	24 hours

Need other regions? Contact us

Support: [e-mail] | [e-mail] | Discord